Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
VisitorID (PK) | Token ID for a visitor. | ID_VSTR | Identity | integer | |
UserName | Optional name assigned to a visitor. Typically these are selected by the user subject to the condition that they're unique within the retailer's list of visitors (and registered parties). | NM_USR | DescriptionShort | varchar(255) | |
UserEmailAddress | The email address of a Visitor. Note that we maintain an email addres as part of the contact information tied to a party. However contact information assumes that a party has registered with the retailer and that is not the case for a first time visitor to the web site (or a store). This attribute is a placeholder for email captured from unregistered, anonymous customers. | ADS_EML_USR | EmailAddress | varchar(253) | |
ConsumerrConversionStateID (FK) | Token ID for a PartyConversionState instance. | ID_CT_CVN_ST | Identity | integer | ConsumerConversionState(CO_CT_CVN_ST) |